#rest api
28 posts

Retrieving GoldenGate logs, reports, and diagnostics with the REST API
I often need to retrieve report files or logs from GoldenGate deployments, and I wanted to find ways of automating this. Hence this blog, about retrieving all available logs with GoldenGate REST API.

How to detect a suspended GoldenGate extract
While testing
EVENTACTIONS (SUSPEND)on an extract, I noticed that nothing inINFOtells you the process is suspended.
Removing instantiation filtering from a GoldenGate replicat
In a recent blog, I explained how instantiation filtering works.
DBOPTIONS ENABLE_INSTANTIATION_FILTERINGmakes a replicat discard any record whose commit CSN is at or below a table's…
Deleting GoldenGate trail files via the REST API (
OGG-30375)When automating your GoldenGate deployments, or tearing down a test environment, handling trail files is important.

GoldenGate 26ai AI Service: Full setup with a free Gemini key
I sometimes get asked how the new AI Service of GoldenGate 26ai works, and the best way to show it is to see it in action.

Rename a GoldenGate Extract with the REST API
In a previous blog, I went through the full procedure of renaming a GoldenGate extract from the
adminclient. I included all necessary steps to avoid missing transactions.
GoldenGate REST API Python client now on
pipIn a previous post, I shared the
OGGRestAPIPython client I built for the GoldenGate REST API. Since then, I kept using it on production deployments, fixing it and adding new features along the way.
NGINX secured distribution path with GoldenGate REST API
In a previous blog, I presented how to set up a distribution path between two GoldenGate deployments both secured with NGINX. The method I used there was purely through the Web UI.

GoldenGate 26ai out-of-place patching with Python
I already covered out-of-place patching from the web UI, but patching tasks should be automated, and clicking through the same screens for every deployment can get repetitive.

Checking long running transactions in GoldenGate
When doing complex operations with GoldenGate, checking for long running transactions is mandatory if you don't want to miss transactions.

Simplified distribution path creation in GoldenGate 26.3
The
23.26.3.0.0release update of GoldenGate 26ai (July 2026) ships a small but welcome usability change, listed in the *New Enhancements section of the release notes: > Bug 39415027: Generic -…
GoldenGate NGINX reverse proxy behavior changes
I recently wrote about NGINX reverse proxy reconfiguration after creating or deleting a deployment in GoldenGate.

Deployment removal failed in GoldenGate Configuration Assistant (
INS-85038)Recently, I wrote about deleting a GoldenGate deployment with the REST API, and when investigating this issue, I remembered a limitation of the configuration assistant, which I wanted to talk about.

Delete a GoldenGate deployment when the password is lost
Recently, I was asked how to recreate a GoldenGate deployment if the password for the
Securityuser (the first user created with the deployment) was lost.
Bulk update of GoldenGate extract profiles
After writing blogs about Default profile updates and a bug affecting profiles in GoldenGate 26ai, I realized it would be a good idea to present a quick way to update all processes at once with the…

GoldenGate 26ai logs explained
GoldenGate logs are a powerful source of information when troubleshooting or analyzing your deployments. However, there is at least one log file per service in the Microservices Architecture.

Monitoring GoldenGate certificates expiration
Your GoldenGate certificates should be granted by a trusted Certificate Authority, which normally handles the monitoring of certificates.

Change GoldenGate Default extract profile
As part of a GoldenGate setup automation, changing the
Defaultprofile of your extracts and replicats seems like a good start if you don't want to deal with custom profiles or changing each…
GoldenGate's undocumented 'all' role you should know about
Let me tell you a story about how I discovered an undocumented role in GoldenGate that could break your automation.

Creating path connections with GoldenGate REST API
When automating your GoldenGate deployment management, you might want to create path connections with the GoldenGate REST API.

OGG-12020payload error in GoldenGate Migration UtilityWhile migrating a GoldenGate classic architecture setup with the migration utility, I recently had the following
OGG-12020error: It is a very cryptic error at first glance, but let's try to…
Create a new GoldenGate deployment with the REST API
Is it possible to create a new GoldenGate deployment with the REST API ? This is the question I will try to answer in this blog, based on my experience with the REST API.

Production-ready GoldenGate REST client in Python
*Updated in June 2026, based on the latest version of the client.

Querying GoldenGate REST API log efficiently
In this blog post, I will guide you on how to query the
restapi.logfile of your GoldenGate deployments more efficiently.
OGG-08116when creating a connection with GoldenGate REST APIWhen playing around with the GoldenGate REST API, you might have encountered the
OGG-08116error.
GoldenGate REST API basics with Python
Oracle GoldenGate REST API has been around for quite some time now, but I've yet to see it used in practice at customers. Every time I tried to introduce it, it was some sort of novelty.

Extend session timeout in GoldenGate Microservices Web UI
If you start using the GoldenGate web UI after installing it, you might end up thinking that extending the session timeout would be nice.

Using Oracle API for MongoDB on OCI
If you've ever had to deal with MongoDB after years (or even decades) of working with SQL, you've probably realized that querying JSON documents can sometimes be painful, to say the least.